<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
    <head>
        <title>JXLL - Excel Addin Interaction Library</title>
		<link rel="shortcut icon" href="favicon.ico" type="image/vnd.microsoft.icon"/>
        <link rel="stylesheet" href="style.css" type="text/css" />
        <meta name="description" content=""/>
        <meta name="keywords" content=""/>
        <meta http-equiv="pragma" content="no-cache"/>    
    </head>

    <body>

    <div id="heading">
        <div class="title"><img src="logo.gif"/>JXLL</div>
        <div class="subtitle">Excel Addin Interaction Library</div>
    </div>
    
    <div class="content">
	
        <div class="section">
            <div class="section-title">About</div>
            <div class="section-content">
            JXLL provides an interface for interacting with Excel Addins (XLLs). It gives java developers access
            to function information and can execute any exposed functions. 
        	<br/><br/>
            JVST is licensed under the <a href="http://www.eclipse.org/legal/cpl-v10.html">Common Public License (CPL)</a>.
            </div>
        </div>
        
		<div class="section">
			<div class="section-title">Download</div>
			<div class="section-content">
				The latest <a href="https://sourceforge.net/project/showfiles.php?group_id=251344">download</a> is available from the Project Page.
			</div>
		</div>

		<div class="section">
			<div class="section-title">Usage</div>
			<div class="section-content">
			The following example shows how to load an XLL and invoke a function:
<pre>
import org.boris.jxll.Addin;
import org.boris.jxll.XLL;
import org.boris.jxll.XLOper;

public class JXLLExample
{
    public static void main(String[] args) throws Exception {
        System.out.println("Loading TestXLL.dll...");
        
        // Load the XLL and check the  result
        Addin a = XLL.load("TestXLL.dll");
        if (a == null) {
            System.out.println("Failed to load addin");
            return;
        }
        
        // Create some random arguments
        double a1 = Math.round(Math.random() * 60000) / 100.;
        double a2 = Math.round(Math.random() * 4000) / 100.;
        System.out.println("Invoking TestSum(" + a1 + "," + a2 + ")");
        
        // Invoke the TestSum functon
        XLOper res = a.invoke("TestSum", new Double(a1), new Double(a2));
        
        // Output the result
        System.out.println(res.num);
    }
}
</pre>
			</div>
		</div>

    
		<div class="section">
			<div class="section-title">Change History</div>
			<div class="section-content">
					V0.0.2
					<ul>
						<li>Improved handling of function registration.</li>
					</ul>
					V0.0.1
					<ul>
						<li>Initial version.</li>
					</ul>
			</div>
		</div>		
    
	</div>
    
    <div id="footer">
		<div class="footer"/>
		<table style="border:0px;width:750px">
		<tr style="border:0px;vertical-align:top">
		<td style="border:0px;vertical-align:top;width:619px">
        <a href="http://www.opensource.org/docs/definition.php"><img border="0" alt="Open Source" src="http://opensource.org/trademarks/open_source_button.png" style="width:88px;height:31px" /></a>
        <a href="http://sourceforge.net"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=251344&amp;type=1" width="88" height="31" border="0" alt="SourceForge.net Logo" /></a>
        </td>
        <td align="right" style="border:0px;vertical-align:top">
        <a href="http://winrun4j.sourceforge.net/"><img border="0" alt="WinRun4J - Configurable Java Launcher for Windows" src="others/winrun4j.gif"/></a>
        <a href="http://xlloop.sourceforge.net/"><img border="0" alt="XLLoop - Excel Functions in Java, Javascript, Ruby, Python, Erlang" src="others/xlloop.gif"/></a>
        <a href="http://variantcodec.sourceforge.net/"><img border="0" alt="VariantCodec - Generic Data Structure Serialization Library for Java" src="others/variantcodec.gif"/></a>
        <a href="http://jvst.sourceforge.net/"><img border="0" alt="JVST - VST Interface for Java" src="others/jvst.gif"/></a>
        <a href="http://jxll.sourceforge.net/"><img border="0" alt="JXLL - Excel Addin Interaction Library" src="others/jxll.gif"/></a>
        <a href="http://expr4j.sourceforge.net/"><img border="0" alt="Expr4J - Expression Calculation Engine for Java" src="others/expr4j.gif"/></a>
        </td>
        </tr>
        </table>
    </div>
</body>
</html>